create  table jms_dm.dm_tab_inport_center_summary_dt
(

    scan_site_code  varchar(100) comment '扫描网点code',
    scan_site_name  varchar(100) comment '扫描网点',
    site_agent_code varchar(100) comment '代理区code',
    site_agent_name varchar(100) comment '代理区name',
    arr_num         int comment '到件总量',
    weight_num      int comment '称重票数',
    weight_pc_num   int comment 'PC端称重票数',
    weight_yd_num   int comment '内场APP称重票数',
    weight_jcd_num  int comment '交叉带称重票数',
    date_time       date comment '日期'
)  ENGINE=OLAP
DUPLICATE KEY(scan_site_code)
COMMENT '中心进港称重报表'
PARTITION BY RANGE(date_time)
(START ('2023-05-01') END ('2023-06-01') EVERY (INTERVAL 1 day)
)
DISTRIBUTED BY HASH(scan_site_code) BUCKETS 1
PROPERTIES (
'replication_num' = '3',
'dynamic_partition.enable' = 'true',
'dynamic_partition.time_unit' = 'DAY',
'dynamic_partition.time_zone' = 'Asia/Shanghai',
'dynamic_partition.start' = '-180',
'dynamic_partition.end' = '3',
'dynamic_partition.prefix' = 'p',
'dynamic_partition.buckets' = '1',
'in_memory' = 'false',
'storage_format' = 'V2'
);